click "OK" for the "Connect to data source to retrieve configuration information" option on the data source options. Complete the configuration of the data source ;
Two. Create a new database Model diagram in VisioOpen Visio, file-> new-> database-> Database Model diagram. After you have established the
Visio 2010 Reverse-Engineering The MySQL database build ER Database model diagram1, first need to download from MySQL for database link drive ODBCYes: http://dev.mysql.com/downloads/connector/odbc/Download it according to the appropriate version and install it locally after
If we want to migrate an old database system to a new database system, it is a great challenge to understand the data structure in the old database system, especially when we have to use early databases on other DBMS platforms, it is even more difficult.
The tools provided by visio enableProgramSmoother, it uses a po
Tags: style blog color io using AR data sp divFirst, in the Visio reverse engineering, there are several abbreviations are U1 ... N, I1 ... N1. U stands for unique KEYU1 represents unique key1,1 for establishing a unique key sequence ordinal2. I stands for INDEXI2 represents index2,2 for established index sequence number3, "required" represents a build table with NOT NULL, cannot insert nullYou can add this
1. Start PD2. Menu: Database->congfigure Connections popup congfigure Data Connections dialog boxClick the Add Data Source button to pop up the Create New DataSource dialog box:We select "System Data Source" and the next step:Data source driver We select SQL Server and proceed to the next step:Click "Done" to pop up the new data source created to SQL Server, where we enter a name, description, and server name or IP:Next: Verify login by selecting SQL
Take IBMDB2For example,VisioReverse join DB2 generationE-R DiagramThe process is as follows:
1. Create an ODBC Data Source
Open Control Panel> Administrative Tools> data source (ODBC) to open the ODBC data source Manager. Select system DSN to add a system data source. Select IBM DB2 odbc druver as the data source driver-> click "finish" and enter the data source name "TEST", database alias "test" (the DB2 databa
Label:How to configure the database driver for VisioBaidu MasterThe fastest Home service, the best quality computer cleaning When you use Visio to reverse-engineer a Database model diagram, you need to configure the database drive
generate a physical database schema for a variety of database management systems (DBMS). Reverse-engineering The structure of the physical database to obtain a logical database schema or an ORM schema. The most recently released Microsoft
introduction
Descriptor
Standalone object types and database property tables
Object Affinity (Nesting)
Add an external uniqueness constraint
Add a detach force role (OR) constraint
Add Value Constraint
Summarize
Reference bibliography
Brief Introduction
Microsoft®visio®for Enterprise Architects (VEA) is included in the Studio®.net Enterprise version of Visual Architect and is cu
I have learned some UML knowledge, but I have never had time to put it into practice. During this time, I wrote a simple inventoryProgramI just wanted to put it into practice. I first created a database model diagram Using Visio. It was a little more intuitive to create a database in Visio and it was quickly completed.
. For example, if you would
Employee(Employee) Object type onto the drawing page, right-click
Employee(employee) and select from the shortcut menu
Show Relationships(show relationship), the page will display the
EmployeeAll the relationships that the (employee) has. This showrelationships (display relationship) feature is useful in schema browsing and reverse engineering, one of many new features that were not previously available in VisioModeler or
Using the Software: Visio 2007: Https://pan.baidu.com/s/1i4LG1IdMain reference: http://blog.csdn.net/zhang_xinxiu/article/details/9392429Http://www.educity.cn/wenda/394495.htmlResults show:Main steps:1. Use reverse engineering to import an already built form into Visio from an MDB;2. Analyze Settings for table associations, associated line styles, and property se
Use PowerDesigner15 to reverse engineer MySQL in win7 (2) win7
Use PowerDesigner15 to reverse engineer MySQL in win7
1. open PowerDesigner, create a new Model, and select Physical Da in Physical Data Model ..
2. select "MySQL5.0" for the DBMS, click "OK", and select "databas
Use PowerDesigner 15 to reverse engineer existing databases and powerdesigner15
1. Start PD
2. Menu: Database-> Congfigure Connections the Congfigure Data Connections dialog box is displayed.
Click Add Data source. The create Data source dialog box is displayed:
Select "System Data Source". Next step:
Select SQL Server as the data source driver and proceed to
In the previous article "using powerdesigner 15 to reverse engineer an existing database (Graphic tutorial 1)", we introduced the data sources required for reverse engineering, this article generates a E-R Graph Based on the created data source. The detailed steps are as follows:
1. Start PD
2. Menu: File>
Because an early project was not output as a E-R chart when the database design was established, the PD was used for reverse engineering of the original database during the secondary transformation and upgrade of the project, that is, all tables in the database are generated into a E-R graph structure based on the data
In the previous article "using powerdesigner for reverse engineering of existing databases (Graphic tutorial 1)", we introduced the data source required for reverse engineering, this article will be based on the data source to create a E-R diagram. The detailed steps are as follows:
1. Start PD
2. Menu: File> reverse engine
succeed, the use of data Management alone is also not necessarily successful, the reason is not very clear, so the final adoption of data Management + Hibernate configuration file, so it's more insurance. )Create a new Hibernate-related profile (Hibernate.properties and Hibernate.cfg.xml) anywhere within the project (test).New hibernate.properties:New Hibernate.cfg.xml:After returning to the Edit configuration form, select the Common tab encoding select UTF-8, other default, click OK buttonIn t
(custom), and select the database you want to connect, as shown in the following figure
4, after the selection is determined, the data source is established successfully, you can double-click the data source name for the connection test, as shown in the following figure
5, this data source is established, of course, these can also not be built here, in the PowerDesigner can also be established, to establish methods for
Select
Database Connection
Menu "Database" à "Connect ...", The following page is displayed:
If no ODBC data source exists, configure the data source.
(Note in SQL2005) When configuring ODBC, after two "Next" buttons are connected, select the "change default database as" check box on the 3rd page, this problem occurs when you select the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.